package com.cloudlead.commonData.query;

import static com.mysema.query.types.PathMetadataFactory.*;
import com.cloudlead.commonData.entity.ETbFleetOrder;


import com.mysema.query.types.path.*;

import com.mysema.query.types.PathMetadata;
import javax.annotation.Generated;
import com.mysema.query.types.Path;

import com.mysema.query.sql.ColumnMetadata;
import java.sql.Types;

import com.mysema.query.sql.*;

import com.cloudlead.common.lang.annotation.Label;


/**
 * QTbFleetOrder is a Querydsl query type for ETbFleetOrder
 */
@Label("车队订单表查询")
@Generated("com.cloudlead.utils.persistence.codegen.serializer.SimpleMetaDataSerializer")
public class QTbFleetOrder extends RelationalPathBase<ETbFleetOrder> {

    private static final long serialVersionUID = -1301075241;

    public static final QTbFleetOrder tbFleetOrder = new QTbFleetOrder("tb_fleet_order");

    public class PrimaryKeys {

        public final PrimaryKey<ETbFleetOrder> primary = createPrimaryKey(id);

    }

    public class ForeignKeys {

        public final ForeignKey<com.cloudlead.commonData.entity.EBaseFleetCustomer> customerCodeFk = createForeignKey(customerCode, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.EBaseDock> tbFleetOrderDockFk = createForeignKey(dockId, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.EBaseCompany> fleetCompanyFk = createForeignKey(fleetCompanyId, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.EBaseVoyage> tbBaseVoyageFk = createForeignKey(baseVoyage, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.ETbCustomerOrder> tbFleetOrderTbCustomerOrder1Fk = createForeignKey(tbCustomerOrderId, "id");

        public final ForeignKey<com.cloudlead.commonData.entity.ETbContainerInfo> _fleetOrderFk = createInvForeignKey(id, "fleet_order_id");

        public final ForeignKey<com.cloudlead.commonData.entity.ETbFleetCost> _fleetOrdersFk = createInvForeignKey(id, "base_fleet_order_id");

    }

    public final StringPath baseVoyage = createString("baseVoyage");

    public final StringPath bussinessCode = createString("bussinessCode");

    public final StringPath cargoName = createString("cargoName");

    public final DateTimePath<org.joda.time.DateTime> createTime = createDateTime("createTime", org.joda.time.DateTime.class);

    public final StringPath customerCode = createString("customerCode");

    public final StringPath delName = createString("delName");

    public final DateTimePath<org.joda.time.DateTime> doBoxDate = createDateTime("doBoxDate", org.joda.time.DateTime.class);

    public final StringPath dockId = createString("dockId");

    public final StringPath flag = createString("flag");

    public final StringPath fleetCompanyId = createString("fleetCompanyId");

    public final StringPath id = createString("id");

    public final StringPath isStart = createString("isStart");

    public final StringPath operatingStaff = createString("operatingStaff");

    public final StringPath orderState = createString("orderState");

    public final StringPath orderType = createString("orderType");

    public final StringPath packagingAddress = createString("packagingAddress");

    public final StringPath polName = createString("polName");

    public final NumberPath<Double> price = createNumber("price", Double.class);

    public final StringPath quantity = createString("quantity");

    public final StringPath removeAddress = createString("removeAddress");

    public final StringPath storeArea = createString("storeArea");

    public final StringPath tbCustomerOrderId = createString("tbCustomerOrderId");

    public final StringPath tbFleetOrdercol = createString("tbFleetOrdercol");

    public final StringPath vesselVoyage = createString("vesselVoyage");

    public final PrimaryKeys pk = new PrimaryKeys();

    public final ForeignKeys fk = new ForeignKeys();

    public QTbFleetOrder(String variable) {
        super(ETbFleetOrder.class, forVariable(variable), "null", "tb_fleet_order");
        addMetadata();
    }

    public QTbFleetOrder(String variable, String schema, String table) {
        super(ETbFleetOrder.class, forVariable(variable), schema, table);
        addMetadata();
    }

    public QTbFleetOrder(Path<? extends ETbFleetOrder> path) {
        super(path.getType(), path.getMetadata(), "null", "tb_fleet_order");
        addMetadata();
    }

    public QTbFleetOrder(PathMetadata<?> metadata) {
        super(ETbFleetOrder.class, metadata, "null", "tb_fleet_order");
        addMetadata();
    }

    public void addMetadata() {
        addMetadata(baseVoyage, ColumnMetadata.named("baseVoyage").withIndex(16).ofType(Types.CHAR).withSize(24));
        addMetadata(bussinessCode, ColumnMetadata.named("bussinessCode").withIndex(13).ofType(Types.VARCHAR).withSize(255));
        addMetadata(cargoName, ColumnMetadata.named("cargoName").withIndex(20).ofType(Types.VARCHAR).withSize(500));
        addMetadata(createTime, ColumnMetadata.named("createTime").withIndex(11).ofType(Types.TIMESTAMP).withSize(19));
        addMetadata(customerCode, ColumnMetadata.named("customerCode").withIndex(21).ofType(Types.CHAR).withSize(24));
        addMetadata(delName, ColumnMetadata.named("del_name").withIndex(15).ofType(Types.VARCHAR).withSize(255));
        addMetadata(doBoxDate, ColumnMetadata.named("doBoxDate").withIndex(2).ofType(Types.TIMESTAMP).withSize(19));
        addMetadata(dockId, ColumnMetadata.named("dockId").withIndex(24).ofType(Types.CHAR).withSize(24));
        addMetadata(flag, ColumnMetadata.named("flag").withIndex(8).ofType(Types.VARCHAR).withSize(8));
        addMetadata(fleetCompanyId, ColumnMetadata.named("fleetCompanyId").withIndex(12).ofType(Types.CHAR).withSize(24));
        addMetadata(id, ColumnMetadata.named("id").withIndex(1).ofType(Types.CHAR).withSize(24).notNull());
        addMetadata(isStart, ColumnMetadata.named("isStart").withIndex(9).ofType(Types.VARCHAR).withSize(8));
        addMetadata(operatingStaff, ColumnMetadata.named("operatingStaff").withIndex(5).ofType(Types.VARCHAR).withSize(45));
        addMetadata(orderState, ColumnMetadata.named("orderState").withIndex(6).ofType(Types.VARCHAR).withSize(100));
        addMetadata(orderType, ColumnMetadata.named("orderType").withIndex(22).ofType(Types.VARCHAR).withSize(10));
        addMetadata(packagingAddress, ColumnMetadata.named("packagingAddress").withIndex(17).ofType(Types.VARCHAR).withSize(500));
        addMetadata(polName, ColumnMetadata.named("pol_name").withIndex(14).ofType(Types.VARCHAR).withSize(255));
        addMetadata(price, ColumnMetadata.named("price").withIndex(4).ofType(Types.DOUBLE).withSize(12));
        addMetadata(quantity, ColumnMetadata.named("quantity").withIndex(3).ofType(Types.VARCHAR).withSize(50));
        addMetadata(removeAddress, ColumnMetadata.named("removeAddress").withIndex(18).ofType(Types.VARCHAR).withSize(500));
        addMetadata(storeArea, ColumnMetadata.named("storeArea").withIndex(19).ofType(Types.VARCHAR).withSize(500));
        addMetadata(tbCustomerOrderId, ColumnMetadata.named("tb_customer_order_id").withIndex(7).ofType(Types.CHAR).withSize(24));
        addMetadata(tbFleetOrdercol, ColumnMetadata.named("tb_fleet_ordercol").withIndex(10).ofType(Types.VARCHAR).withSize(45));
        addMetadata(vesselVoyage, ColumnMetadata.named("vesselVoyage").withIndex(23).ofType(Types.VARCHAR).withSize(100));
    }

}

